AwardYear

EntityType | Independent
Logical Entity Name | AwardYear
Default Table Name | FaYear
Logical Only | NO
Owner | dbo
Definition |
Note |

AwardYear Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Code |  | CHAR(9) | NO |
Name |  | VARCHAR(30) | NO |
StartDate |  | DATETIME | NO |
EndDate |  | DATETIME | NO |
DateAdded |  | DATETIME | NO |
DateLstMod |  | DATETIME | NO |
UserID |  | INTEGER | NO |
IsActive |  | BIT | NO |
ModFlag |  | CHAR(1) | NO |
ts |  | TIMESTAMP/DATE | NO |
AwardYearIdentifier |  | CHAR(2) | NO |
IsDisplayedInUi |  | INTEGER | NO |

AwardYear Keys

Key Name | Key Type | Keys
FaYear_FaYearID_U_C_IDX | PrimaryKey | AwardYearIdentifier

AwardYear Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
GainfulEmploymentAwardYearSchema | Non-Identifying | One To Zero or More |  |  |  |  | NO
GainfulEmploymentReportStudent | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaAaiTaxRate | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaAwardYearMaxAmt | Non-Identifying | One To Zero or More |  |  |  |  | NO
PellAwardAmountGrid | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaCfpGrantOptionsConfig_Regulatory | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaCfpInterestRateConfig_Regulatory | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaCfpWorkStudyConfig_Regulatory | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaEducationSavingsAllowance | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFAFSAAwardYearSchema | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFisapIncomeBracket | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaIncomeProtectionAllowance | Non-Identifying | One To Zero or More |  |  |  |  | NO
IsirAssumptionCode | Non-Identifying | One To Zero or More |  |  |  |  | NO
IsirAwardYearSchema | Non-Identifying | One To Zero or More |  |  |  |  | NO
IsirCorrection | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaISIRImportTrackLog | Non-Identifying | One To Zero or More |  |  |  |  | NO
IsirRejectCode | Non-Identifying | One To Zero or More |  |  |  |  | NO
IsirRawData | Non-Identifying | One To Zero or More |  |  |  |  | NO
IsirMatch | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaNetWorthAdjustment | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaShoppingSheetCommentsConfig | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaShoppingSheetCostsConfig | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaShoppingSheetLoanOptionsConfig | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaSocialSecurityTaxRate | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaStateTaxAllowance | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaYearExternalMap | Non-Identifying | One To Zero or More |  |  |  |  | NO

AwardYear Check Constraints

Check Constraint Name | CheckConstraint

AwardYear Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.AwardYear | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaYear | NO |  |  |

AwardYear Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records
Physical (Microsoft SQL Server) | Financial Aid

AwardYear Data Movement Rules

Name | Type | Rule Text/Value